CUBE CONNECT Edition Help

Update Data

The Compute tool in table editor lets you update field values in a table, based on conditions. These conditions can be used to filter rows to include in the update.

  1. Click Toolbar > Update

  2. Enter the expressions for updating the field values in the expression box on the top and the expressions for filtering the rows in the box below.

    • Enter the name of the field whose value you want to change. Select the matching one from the autocomplete list.
      Tip: For a complete list of field suggestions use the shortcut: CTRL+SHIFT+C
    • Use the assignment operator ‘=’ to assign the field its new value (numeric or non-numeric).
    • Enter a numeric or string value after the operator:

  3. Click Apply
    • Whenever you apply a condition the status bar on the bottom right will show if the filtering process is still in progress.
      Tip: More than one field can be updated by separating the field expressions with a comma

  4. To clear the condition box, click on the drop-down next to Apply and select Clear